package com.sushuo.api.dao;

import com.sushuo.base.bean.OprSpecialty;

public interface OprSpecialtyDao extends BaseDao<OprSpecialty, Integer>{
    public static final String PAGE_SELECT = "SELECT i.*, CASE WHEN i.start_time <= NOW() AND NOW() <= i.end_time THEN '3' WHEN i.start_time > NOW() THEN '2' WHEN i.end_time <= NOW() THEN '1' ELSE '0' END AS online_status FROM t_opr_specialty i ";
    public static final String PAGE_ORDER_BY = "ORDER BY online_status DESC, i.start_time ASC ";
}
